<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

    <title>My JSP 'login.jsp' starting page</title>

</head>

<body>
<h3><font color="FF0000">${username }</font>的后台管理页面：查询示例二（筛选条件组合查询）</h3>
<P>

<form action="${pageContext.request.contextPath }/Comb_Qu.action"
      method="post">
    学生姓名：<input type="text" name="username"> <br>
    家庭住址：<input type="text" name="address"> <br>
    学生性别：<select name="sex">
    <option value="男">male</option>
    <option value="女">female</option>
</select> <br>
    高考成绩：<select name="score_cmp">
    <option value=">=">large or equal</option>
    <option value="=">equal</option>
    <option value="<=">less or equal</option>
</select>
    <input type="text" name="score"> <br>
    <input type="submit" value="查询">
</form>

显示数据库表
<br>
满足查询：<font color=red>${a }</font>，关键字：<font color=red>${key }</font> 的条件如下：<br>
<table border="1">
    <tr bgcolor="aabbcc">
        <th>序号</th>
        <th>姓名</th>
        <th>家庭住址</th>
        <th>性别</th>
        <th>高考成绩</th>
    </tr>
    <c:forEach var="lists" items="${requestScope.stu_list }"
               varStatus="s">
        <tr>
            <td>${s.count}</td>
            <td>${lists.username }</td>
            <td>${lists.address }</td>
            <td>${lists.sex }</td>
            <td>${lists.score }</td>
        </tr>
    </c:forEach>
</table>
<br>
<br>
返回
<br>
</body>
</html>
